Skip to main content

Aggregation and Functional dependency in DBMS-computer world


 
Aggregation and Functional dependency in DBMS


Aggregation 

In aggregation the relation between two entities is treated as a single entity. In aggregation relationship with its corresponding entity is aggregated into higher level entity . It is the process of compiling information on object, there by obstructing a higher level. On limitation of the ER model is that it can not Express relationship among relationships. The aggregation represent a relationship between a whole object and its component in other word we can say that using aggregation we can express relationship main relationships.

 For example center entity offer the course entity act as a single entity in the relationship which is in a relationship with another entity visitor. In the real world if a visitor visits a coaching center they will never inquiry about the course or just about the center instead he will ask the inquiry about both.

Functional dependency

 Functional dependency play an important role in differentiating good database resign from not so good database region functional dependency are conservation of the internal relationship among attribute of an entity represent by relation functional dependency is a relationship the exist attribute it typically exist between the primary key and non key attribute within a table in other words we can say that functional dependency in DBMS, as the name suggest in a relationship between attribute of a table dependent on each other it helps in preventing data and gets to know about bad design.


In this example if we know the value of employee number , we can obtain employee name, City , salary etc. By this we can say that the employee city, employee name and employee salary are functionally dependent on employee number.

  Database system vs file system

 Nested relation

what is computer worm-computer world

  What is google Search Engine

Logical database model and  Relational database management system

Definition of computer cables and types of cables

Register and type of register in computer Architecture

What is buffering

Definition of computer ports and types of ports

what is computer and what is the meaning of computer

Definition of computer cables and types of cables

Difference between Linux and Unix-computer world

Demand paging-oocomputer world

  What is CSS-computer world

What is internet-computer world

Round-Robin Scheduling in operating system-computer world



Comments

Popular posts from this blog

Difference between HTML and DHTML-computer world

     Difference between HTML and DHTML  HTML is a markup language, while DHTML is a collection of Technology.  DHTML creates dynamic web page, whereas HTML create static web page.  DHTML allow including small animations and dynamic menus in web pages but HTML is not able to do so.   HTML used events, methods, properties to insulate dynamism in HTML pages.   HTML is used to describe the web page but DHTML is a collection of JavaScript and style sheet in an HTML page. HTML sites will be show upon client side Technologies, while  DHTML site will be fast enough upon client side Technologies as most of entries are checked on browser itself and not waste time rendering to server for mistake.  HTML creates a plain web page without any style and scripts called as HTML. Whereas,  DHTML creates a page with HTML, CSS,DOM And scripts called as DHTML.  HTML cannot any server side code but XHTML may contain server side code.  ...

Deadlock in operating system-computer world

  Deadlock in operating system-computer world Deadlock :  In a multi-programming environment, many process may complete for a minute number of resources. A process make a request for a resource and if the resource is not available at that time, the process enter In a waiting state. A waiting state process is never again-able to change state because the resource it has requested is held by other waiting process. This situation is called deadlock. So we can say that a process is said to be deadlock when it is waiting for an event or resources which will never occurs.   so we can say that in this situation none of the process gets executed  since the resource it needs, is held by some other process which is also waits for some other resource to be released.  Let's assume that there are three process P1, P2, p3 and three different resources R1, R2 and R3. R1 is assigned to p1, R2 is assigned to P2 and R3 is assigned to P3.   After somet...